package com.project2.mapper;

import com.project2.bean.po.MarketChannel;
import com.project2.bean.po.MarketOrder;
import com.project2.bean.po.MarketOrderExample;
import com.project2.bean.vo.StatInnerRowsVo;
import org.apache.ibatis.annotations.Param;

import java.util.Date;
import java.util.ArrayList;
import java.util.Date;


import java.util.List;

public interface MarketOrderMapper {
    long countByExample(MarketOrderExample example);

    int deleteByExample(MarketOrderExample example);

    int deleteByPrimaryKey(Integer id);

    int insert(MarketOrder record);

    int insertSelective(MarketOrder record);

    List<MarketOrder> selectByExample(MarketOrderExample example);

    MarketOrder selectByPrimaryKey(Integer id);

    int updateByExampleSelective(@Param("record") MarketOrder record, @Param("example") MarketOrderExample example);

    int updateByExample(@Param("record") MarketOrder record, @Param("example") MarketOrderExample example);

    int updateByPrimaryKeySelective(MarketOrder record);

    int updateByPrimaryKey(MarketOrder record);


    List<MarketChannel> selectAll();

    ArrayList<StatInnerRowsVo> ordersCount();

    String selectShipNameByCode(String shipChannel);


    List<MarketOrder> selectUserOrderState(Integer id);

     int  updateOrderCommentById(@Param("id") Integer orderId,@Param("num") Short number,@Param("date") Date date);

    List<MarketOrder> selectAllStatusBystatus(@Param("id") Integer userId);

    List<MarketOrder> selectTwoStatus();

    List<MarketOrder> selectAllStatusBystatus(@Param("s1") int s1, @Param("s2") int s2, @Param("s3") int s3, @Param("s4") int s4);


}